CREATE VIEW [dbo].[vSoaPendingARPaymentAdjustment] WITH SCHEMABINDING
AS
SELECT [INVOICE_REFERENCE_NUM],
       [INVOICE_LINE_NUM],
       SUM([INVOICE_CREDITS] - [INVOICE_CHARGES]) AS Amount,
       COUNT_BIG(*) [Count]
  FROM [dbo].Trans
  WHERE [POSTED] < 2 AND [TRANSACTION_TYPE] = 'AR' AND [JOURNAL_TYPE] = 'PAY' AND [INVOICE_REFERENCE_NUM] != 0
  GROUP BY [INVOICE_REFERENCE_NUM], [INVOICE_LINE_NUM]

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaPendingARPaymentAdjustment] ON [dbo].[vSoaPendingARPaymentAdjustment] ([INVOICE_REFERENCE_NUM], [INVOICE_LINE_NUM]) ON [PRIMARY]
GO